Parameters
- index
- The zero-based index of the parameter to retrieve.
public void CreateZohoDeskParamColl(ZohoDeskCommand ZohoDeskCommand) { ZohoDeskParameterCollection myParamCollection = ZohoDeskCommand.Parameters; myParamCollection.Add("DeptNo", DbType.Integer); myParamCollection.Add("DName", DbType.VarChar); myParamCollection.Add("Loc", DbType.VarChar); string myParamNames = ""; for (int i=0; i < myParamCollection.Count; i++) myParamNames += myParamCollection[i].ToString() + "\n"; MessageBox.Show(myParamNames); myParamCollection.Clear(); }
Public Sub CreateZohoDeskParamColl(ZohoDeskCommand As ZohoDeskCommand) Dim myParamCollection As ZohoDeskParameterCollection = ZohoDeskCommand.Parameters myParamCollection.Add("DeptNo", DbType.Integer) myParamCollection.Add("DName", DbType.VarChar) myParamCollection.Add("Loc", DbType.VarChar) Dim myParamNames As String = "" Dim i As Integer For i = 0 To myParamCollection.Count - 1 myParamNames += myParamCollection(i).ToString() + ControlChars.Cr Next i MessageBox.Show(myParamNames) myParamCollection.Clear() End Sub